From 597d7748b980b8410c9d8e1e61b3bd4dc74c024e Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 20 Oct 2025 21:02:20 +0000 Subject: [PATCH] Solve conversion problem #50; females with n/a cycle codes --- conversion/clean.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index 37fdd4e..075f6d7 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -241,6 +241,15 @@ UPDATE follow -- Update the follow_arrival.fa_type_of_cycle -- +-- Females are not allowed to have a n/a code +-- Problem #50 +UPDATE follow_arrival + SET fa_type_of_cycle = 'MISS' + FROM biography + WHERE follow_arrival.fa_type_of_cycle = 'NA' + AND biography.b_animid = follow_arrival.fa_b_arr_animid + AND biography.b_sex = 'F'; + -- There must be no NULL fa_type_of_cycle values. Problem #42. UPDATE follow_arrival SET fa_type_of_cycle = 'MISS' -- 2.34.1